<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <title>Force Dovecot to recalculate mailbox quota</title>
        <link rel="stylesheet" type="text/css" href="./css/markdown.css" />
    </head>
    <body>

    <div id="navigation">
    <a href="https://www.iredmail.org" target="_blank">
        <img alt="iRedMail web site"
             src="./images/logo-iredmail.png"
             style="vertical-align: middle; height: 30px;"
             />&nbsp;
        <span>iRedMail</span>
    </a>
    &nbsp;&nbsp;//&nbsp;&nbsp;<a href="./index.html">Document Index</a></div><h1 id="force-dovecot-to-recalculate-mailbox-quota">Force Dovecot to recalculate mailbox quota</h1>
<h2 id="dovecot-2x">Dovecot-2.x</h2>
<p>Dovecot provides command line tool <code>doveadm</code> to recalcuate mailbox quota.
Sample usage:</p>
<ul>
<li>Recalculate one mailbox:</li>
</ul>
<pre><code>doveadm quota recalc -u user@domain.ltd
</code></pre>
<ul>
<li>Recalculate ALL mail accounts:</li>
</ul>
<pre><code>doveadm quota recalc -A
</code></pre>
<p>Reference: <a href="http://wiki2.dovecot.org/Tools/Doveadm/Quota">Doveadm-Quota</a></p>
<h2 id="dovecot-1x-and-dovecot-2x">Dovecot-1.x and Dovecot-2.x</h2>
<p>iRedMail enables dict quota since iRedMail-0.7.0, dict quota is recalculated
only if the quota goes below zero.</p>
<ul>
<li>For MySQL and PostgreSQL backend:</li>
</ul>
<pre><code>mysql&gt; USE vmail;
mysql&gt; DELETE FROM used_quota WHERE username='user@domain.ltd';
</code></pre>
<ul>
<li>For OpenLDAP backend:</li>
</ul>
<pre><code>mysql&gt; USE iredadmin;
mysql&gt; DELETE FROM used_quota WHERE username='user@domain.ltd';
</code></pre>
<p>Re-login via POP3/IMAP (or webmail) will trigger Dovecot to recalculate mailbox
quota.</p>
<p><strong>TIP</strong>: it's safe to delete records in SQL table <code>used_quota</code> if mail user
was deleted in table <code>vmail.mailbox</code> or LDAP. iRedAdmin-Pro will handle this
for you automatically.</p><div class="footer">
    <p style="text-align: center; color: grey;">All documents are available in <a href="https://github.com/iredmail/docs/">GitHub repository</a>, and published under <a href="http://creativecommons.org/licenses/by-nd/3.0/us/" target="_blank">Creative Commons</a> license. You can <a href="https://github.com/iredmail/docs/archive/master.zip">download the latest version</a> for offline reading. If you found something wrong, please do <a href="https://www.iredmail.org/contact.html">contact us</a> to fix it.</p>
</div></body></html>